﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace QLXMDataAccessLayer.Utils
{
    public class SPConstants
    {
        /* public const string TLNVDownloadHistory = "Download TLNV";
         // Quan ly thiet bi
         // -- SP
         public const string QLTB_SPDelete = "QLDD_DeleteThietBi";
         public const string QLTB_SPGetTotalRowThietBi = "QLDD_SumThietBi";
         public const string QLTB_SPGetTotalRowNguoiSuDungVatTu = "QLDD_SumNSDVatTu";
         public const string QLTB_SPGetThietBi = "QLDD_GetThietbi";
         public const string QLTB_SPCheckExistThietBi = "QLDD_CheckExistTB";
         public const string QLTB_SPCheckExistTaiLieuNV = "QLDD_CheckExistTaiLieuNV";
         public const string QLTB_SPCheckExistNguoiSDVattu = "QLDD_CheckExistNguoiSuDungVatTu";
         public const string QLTB_SPInsertThietBi = "QLDD_InsertThietBi";
         public const string QLTB_SPInsertNguoiSudungVatTu = "QLDD_InsertNguoiSuDungVatTu";
         public const string QLTB_SPInsertTaiLieuNV = "QLDD_InsertTaiLieuNghiepVu";
         public const string QLTB_SPInsertLichSuCapNhat = "QLDD_InsertLichSuCapNhat";
         public const string QLTB_SPEditThietBi = "QLDD_EditThietBi";
         public const string QLTB_SPEditNguoiSuDungVattu = "QLDD_EditNguoiSuDungVattu";
         public const string QLTB_SPGetNguoiSuDungVatTu = "QLDD_GetNguoiSuDungVatTu";

         // Tai Lieu Nghiep Vu
         public const string QLTB_SPGetTLNVHL = "QLDD_GetTaiLieuNghiepVuHieuLuc";
         public const string QLTB_SPGetTLNV = "QLDD_GetTaiLieuNghiepVu";
         public const string QLTB_SPGetTotalRowTLNV = "QLDD_SumTLNV";
         public static string QLTB_SPEditTaiLieu = "QLDD_EditTaiLieu";
         public static string QLTB_SPDelTaiLieu = "QLDD_DeleteTaiLieu";
         public const string QLTB_SPCheckExistNVDB = "QLDD_CheckExistNVDB";
         public static string QLTB_SPCheckExistAddNVDB = "QLDD_CheckExistAddNVDB";
         // Qui Che Cham diem
         public const string QLTB_SPCheckExistQuiChe = "QLDD_CheckExistQuiChe";
         public const string QLTB_SPGetQuiChe = "QLDD_GetQuiCheChamDiem";
         public const string QLTB_SPGetTotalRowQuiChe = "QLDD_SumQuiChe";
         public static string QLTB_SPEditQuiChe = "QLDD_EditQuiChe";
         public static string QLTB_SPDelQuiChe = "QLDD_DeleteQuiChe";
         public const string QLTB_SPInsertQuiChe = "QLDD_InsertQuiChe";

         public const string QLTB_SPGetTotalRowChamDiemNV = "QLDD_SumChamDiemNV";
         public const string QLTB_SPGetChamDiemNV = "QLDD_GetChamDiemNV";
         public const string QLTB_SPInsertChamDiemNV = "QLDD_InsertChamDiemNV";


         public const string QLTB_SPGetBaoCaoChamDiemByNV = "QLDD_GetBaoCaoChamDiemByNV";
         public const string QLTB_SPGetBaoCaoChamDiemByTT = "QLDD_GetBaoCaoChamDiemByToThu";
         public const string QLTB_SPGetBaoCaoChamDiemByNVALL = "QLDD_GetBaoCaoChamDiemByNVALL";
         public const string QLTB_SPGetBaoCaoChamDiemByTTALL = "QLDD_GetBaoCaoChamDiemByToThuALL";
         public const string QLTB_SPGetTotalRowBCChamDiemNV = "QLDD_SumBCChamDiemByNV";
         public const string QLTB_SPGetTotalRowBCChamDiemTT = "QLDD_SumBCChamDiemByToThu";

         // Quan Ly Nhan Vien Dia Ban
         public const string QLTB_SPGetDanhSachNVDBByCondition = "QLDD_ExportDanhSachNVDB";
         public const string QLTB_SPGetDanhSachNVDB = "QLDD_GetDanhSachNVDB";
         public const string QLTB_SPGetNVDB = "QLDD_GetNVDB";
         public const string QLTB_SPGetTotalRowNVDB = "QLDD_SumNVDB";
         public static string QLTB_SPDelNVDB = "QLDD_DeleteNVDB";
         public static string QLTB_SPEditNVDB = "QLDD_EditNVDB";
         public const string QLTB_SPInsertNVDB = "QLDD_InsertNVDB";

         // -- Param SQL
         public const string QLTB_ParamBeginRow = "beginRow";
         public const string QLTB_ParamToRow = "toRow";
         public const string QLTB_ParamCondition = "_condition";
         public const string QLTB_ParamMaThuCuoc = "pmathucuoc";

         // Thi Nghiep Vu
         public const string QLDD_GetQuestionsByTopicIdForExam = "QLDD_GetQuestionsByTopicIdForExam";
         public const string QLDD_GetQuestionsByTopicId = "QLDD_GetQuestionsByTopicId";
         public const string QLDD_GetQuestionsByResultId = "QLDD_GetQuestionsByResultId";
         public const string QLDD_GetTopic = "QLDD_GetTopic";
         public const string QLDD_GetAsnwerType = "QLDD_GetAsnwerType";
         public const string QLDD_SaveResulTTV = "QLDD_SaveResulTTV";
         public const string QLDD_SaveResulDetailTTV = "QLDD_SaveResulDetailTTV";
         public const string QLDD_GetTopicTime = "QLDD_GetTopicTime";
         public const string QLDD_GetTotalTopic = "QLDD_GetTotalTopic";
         public const string QLDD_GetTopicALL = "QLDD_GetTopicALL";
         public const string QLDD_GetTopicAllNoPaging = "QLDD_GetTopicAllNoPaging";        
         public const string QLDD_DeleteTopic = "QLDD_DeleteTopic";
         public const string QLDD_CheckExistTopic = "QLDD_CheckExistTopic";
         public const string QLDD_InsertTopic = "QLDD_InsertTopic";
         public const string QLDD_UpdateTopic = "QLDD_UpdateTopic";
         public const string QLDD_GetTotalQuestion = "QLDD_GetTotalQuestion";
         public const string QLDD_GetQuestionALL = "QLDD_GetQuestionALL";
         public const string QLDD_DeleteTopicQuestion = "QLDD_DeleteTopicQuestion";
         public const string QLDD_CheckExistQuestion = "QLDD_CheckExistQuestion";
         public const string QLDD_InsertQuestion = "QLDD_InsertQuestion";
         public const string QLDD_UpdateQuestion = "QLDD_UpdateQuestion";
         public const string QLDD_DeleteQuestion = "QLDD_DeleteQuestion";
         public const string QLDD_GetTotalAnswerByQuestionId = "QLDD_GetTotalAnswerByQuestionId";
         public const string QLDD_GetAnswerByQuestionId = "QLDD_GetAnswerByQuestionId";
         public const string QLDD_DeleteAnswer = "QLDD_DeleteAnswer";
         public const string QLDD_CheckExistAnswer = "QLDD_CheckExistAnswer";
         public const string QLDD_InsertAnswer = "QLDD_InsertAnswer";
         public const string QLDD_UpdateAnswer = "QLDD_UpdateAnswer";
         public const string QLDD_AssignQuestionToTopic = "QLDD_AssignQuestionToTopic";
         public const string QLDD_ResultAll = "QLDD_ResultAll";
         public const string QLDD_ResultAllNoPaging = "QLDD_ResultAllNoPaging";
         public const string QLDD_GetTotalResult = "QLDD_GetTotalResult";
         public const string QLDD_ResultDetailAll = "QLDD_ResultDetailAll";
         public const string QLDD_GetTotalResultDetail = "QLDD_GetTotalResultDetail";
         public const string QLDD_GetTotalQuestionNotInTopicId = "QLDD_GetTotalQuestionNotInTopicId";
         public const string QLDD_GetQuestionNotInTopicId = "QLDD_GetQuestionNotInTopicId";
         public const string QLDD_GetQuestionAllNoPaging = "QLDD_GetQuestionAllNoPaging";
         public const string QLDD_UpdateResultAllowReTest = "QLDD_UpdateResultAllowReTest";        

         //Quy dong doi
         public const string QLTB_SPGetTotalRowThuQuyDongDoi = "QLTB_SPGetTotalRowThuQuyDongDoi";
         public const string QLTB_SPGetThuQuyDongDoi = "QLTB_SPGetThuQuyDongDoi";
         public const string QLTB_SPInsertThuQuyDongDoi = "QLTB_SPInsertThuQuyDongDoi";
         public const string QLTB_SPUpdateThuQuyDongDoi = "QLTB_SPUpdateThuQuyDongDoi";
         public const string QLTB_SPUpdateStatusThuQuyDongDoi = "QLTB_SPUpdateStatusThuQuyDongDoi";        
         public const string QLTB_SPDeleteThuQuyDongDoi = "QLTB_SPDeleteThuQuyDongDoi";
         public const string QLTB_SPGetTotalRowChiQuyDongDoi = "QLTB_SPGetTotalRowChiQuyDongDoi";
         public const string QLTB_SPGetChiQuyDongDoi = "QLTB_SPGetChiQuyDongDoi";
         public const string QLTB_SPInsertChiQuyDongDoi = "QLTB_SPInsertChiQuyDongDoi";
         public const string QLTB_SPUpdateChiQuyDongDoi = "QLTB_SPUpdateChiQuyDongDoi";
         public const string QLTB_SPUpdateStatusChiQuyDongDoi = "QLTB_SPUpdateStatusChiQuyDongDoi";
         public const string QLTB_SPDeleteChiQuyDongDoi = "QLTB_SPDeleteChiQuyDongDoi";
         public const string QLTB_SPGetChiQuyDongDoiNoPaging = "QLTB_SPGetChiQuyDongDoiNoPaging";
         public const string QLTB_SPGetThuQuyDongDoiNoPaging = "QLTB_SPGetThuQuyDongDoiNoPaging";
         public const string QLTB_SPUpdatePhatSinhGiam = "QLTB_SPUpdatePhatSinhGiam";
         public const string QLTB_SPUpdatePhatSinhTang = "QLTB_SPUpdatePhatSinhTang";


         public static string QLTB_SPGetChamDiemNVALL = "QLDD_GetChamDiemNVAll";

         //Quan lt thu nhap
         public const string QLTN_InsertQLTNLuongXacMinhKhachHang = "QLTN_InsertQLTNLuongXacMinhKhachHang";
         public const string QLTN_InsertQLTNTongHopThuNhap = "QLTN_InsertQLTNTongHopThuNhap";
         public const string QLTN_SPInsertLuongHoaBanHang = "QLTN_SPInsertLuongHoaBanHang";
         public const string QLTN_SPInsertLuongThuCuoc = "QLTN_SPInsertLuongThuCuoc";

         public const string QLTN_GetLuongXacMinhKhachHang = "QLTN_GetLuongXacMinhKhachHang";
         public const string QLTN_GetTongHopThuNhap = "QLTN_GetTongHopThuNhap";
         public const string QLTN_GetLuongHoaHongBanHang = "QLTN_GetLuongHoaHongBanHang";
         public const string QLTN_GetLuongThuCuoc = "QLTN_GetLuongThuCuoc";
         * * */
    }
        
}